﻿using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace DAL
{
    public class VaiTro
    {
        //private const String SConn = "Data Source=DUCLINH-PC;Initial Catalog=HOUSMS;Persist Security Info=True;User ID=sa;Password=minhduc";
        private string SConn = ConfigurationManager.ConnectionStrings["DucLM"].ConnectionString;

        public DataSet GetDataSet()
        {
            var conn = new SqlConnection(SConn);
            var cmd = new SqlCommand("LoadRole", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            var da = new SqlDataAdapter(cmd);
            var ds = new DataSet();
            da.Fill(ds);
            return ds;
        }
    }
}
